UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K5RpQlhYieFuPhKM6jIJbESTbHkxCCaV1O9W1rEsBI8='
WHERE
key_id = 'd29bc75b0484635d4349f920fd1dd8e2daaae0d29110ec49c618f2a45d67d68f'
AND (
token = 'K5RpQlhYieFuPhKM6jIJbESTbHkxCCaV1O9W1rEsBI8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)