UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K7Jk/ovw/Bybthrjhvl7PjG+R0yr7SlFWU3DIy8L+rg='
WHERE
key_id = '5b0fcd47aaa115d6905833bd52ed181d92d5199983f4340350fa426ab5cf1978'
AND (
token = 'K7Jk/ovw/Bybthrjhvl7PjG+R0yr7SlFWU3DIy8L+rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)