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