UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j+M+VHHd6s82y+2+dkD/RH+6pe88+YCAfnr3B4aPJJc='
WHERE
key_id = '6eaeef398ab75485356e793bca49e7104d7784f56c87488fb6f4ea54713c44ee'
AND (
token = 'j+M+VHHd6s82y+2+dkD/RH+6pe88+YCAfnr3B4aPJJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)