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