UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CV6jxpJlBGQu+7/MdoZHW0LlFBx423eANIOwVldysV4='
WHERE
key_id = '1d9959994a922dd61957e45801739107da81b1285ceee770c4b47f948fc802ec'
AND (
token = 'CV6jxpJlBGQu+7/MdoZHW0LlFBx423eANIOwVldysV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)