UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sDTCm9PInd9rWk+CaoUh6sV/R78ThdBu0B17CfOWcHg='
WHERE
key_id = 'b557695d4b485158de043d7ae78e19835bec98a0251a7534263265ea2d38142b'
AND (
token = 'sDTCm9PInd9rWk+CaoUh6sV/R78ThdBu0B17CfOWcHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)