UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/0AuSvuPKMnICw47kNYQTrMzQnB7XAAwpVIo7O/IPK8='
WHERE
key_id = '4497c91464fc9e0673f43ea43ad0434ae8cbff54086ebba5b25a410a3c58d8e2'
AND (
token = '/0AuSvuPKMnICw47kNYQTrMzQnB7XAAwpVIo7O/IPK8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)