UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZncJC+LgCQmr3lUqmieGrlVgJS1CJc+8JjqRsL5eTlc='
WHERE
key_id = 'e4c1882281098ab9e2787e203a89e757a5ded374cadd29b5a6b1aca33a6bd217'
AND (
token = 'ZncJC+LgCQmr3lUqmieGrlVgJS1CJc+8JjqRsL5eTlc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)