UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0oSdaGjOCS24dSyKkA6v9uZDXoVpfzW0lFfcSLcIfkQ='
WHERE
key_id = 'ed7c9f914ae55d4de4720819a76ec69d05ce72dfb333f5b179d4dbc4ecd19e53'
AND (
token = '0oSdaGjOCS24dSyKkA6v9uZDXoVpfzW0lFfcSLcIfkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)