UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QgeROwihfuS0+xrHi0LTKUtllt1U7I/AR6OMtawA6zc='
WHERE
key_id = 'e7a4e8a59fd7bcf4fdf2ec26b174504887b0f7eb46cff3c6ee65ceb1c05acba6'
AND (
token = 'QgeROwihfuS0+xrHi0LTKUtllt1U7I/AR6OMtawA6zc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)