UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Z6rxHsNJiBVBAMF0NsAqKDUgoIGamHv03DZqIbdfxM='
WHERE
key_id = '3f4329ec835161020a136ab91a1b5709356aaa7627c1cae1efaa57f3992f8011'
AND (
token = '8Z6rxHsNJiBVBAMF0NsAqKDUgoIGamHv03DZqIbdfxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)