UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9p+vtcKyHgBahru6oe02yFmhsJWdjJKKB1f3gFgtmaI='
WHERE
key_id = '0a4b80f379ec6fcad0d64b8888c022606f8f1647c354b7203cfa9838ed823fce'
AND (
token = '9p+vtcKyHgBahru6oe02yFmhsJWdjJKKB1f3gFgtmaI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)