UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pbe7vKIItVqPbYBpyMbjw0h94LL5+Anx2kDrH5uKMDk='
WHERE
key_id = 'c1d6a8f1c6b707257c223b369df74870f7920827e7edaae72526c6e8f58064b3'
AND (
token = 'pbe7vKIItVqPbYBpyMbjw0h94LL5+Anx2kDrH5uKMDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)