UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Tn6GgL0VC0olrKc35vPgmdmoEtgdgRBwM0XebXHHws='
WHERE
key_id = 'c60f4566e78f1aecda3846ab9ccaeab75534627698a5ce05bfeb051d027b68ed'
AND (
token = '/Tn6GgL0VC0olrKc35vPgmdmoEtgdgRBwM0XebXHHws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)