UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6ucAihmch8y4xmxnegtRtpLr8BGEo29DPo69LpLcF+E='
WHERE
key_id = '823592937425b0762095a9d13c6f7881c99e99e5c4238216b36eff5785626835'
AND (
token = '6ucAihmch8y4xmxnegtRtpLr8BGEo29DPo69LpLcF+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)