UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'STc1RnjwNYnO6J98eLya90luKbpklMzzeafXUzXF8CU='
WHERE
key_id = '7c7b0bf270fdf5bc2563c8291d942daaeaf5f2df2364acbf843aa83156f2ff52'
AND (
token = 'STc1RnjwNYnO6J98eLya90luKbpklMzzeafXUzXF8CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)