UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '78OuE3FlkVFMrTKjfr6wBrXLFXeGllpD8W0+cu/glZA='
WHERE
key_id = 'd6c61dbd44fd18a0871a728574572d98311e1e873e6a0c4555d54d862220eb0c'
AND (
token = '78OuE3FlkVFMrTKjfr6wBrXLFXeGllpD8W0+cu/glZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)