UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wAlVpZIztEGm+/XZrfzFlXD4uVeNoD9gVg7yFobqZc8='
WHERE
key_id = 'c93831a8f144317cf653ad680617a3ada235f042dbbed70dc22f3d57d8043ec8'
AND (
token = 'wAlVpZIztEGm+/XZrfzFlXD4uVeNoD9gVg7yFobqZc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)