UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XI/eh5awlD6s4RtcHlURI407QzJLnjyPqd+c3iwrW5g='
WHERE
key_id = '7cf31d8fd6b4503b3c94e3398df744ba45f07da4a3e86dddc7b781d0df721d58'
AND (
token = 'XI/eh5awlD6s4RtcHlURI407QzJLnjyPqd+c3iwrW5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)