UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G5vw8lVOuwUGUWKMLNJ+zlRPyeDeYKhrHxMM39ZDV+Y='
WHERE
key_id = '1e80975947635828ba23b57ef9860d76262e914e0bdbc66de2edf19e6bb06ad9'
AND (
token = 'G5vw8lVOuwUGUWKMLNJ+zlRPyeDeYKhrHxMM39ZDV+Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)