UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8LKU0VW3gGTMT5Bny5hqNCD2ZdXiodqdSuEXa+aJNIs='
WHERE
key_id = '724067d2430096f809def03c95e208516445d84af6ad99c3953bc068db6b0400'
AND (
token = '8LKU0VW3gGTMT5Bny5hqNCD2ZdXiodqdSuEXa+aJNIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)