UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '892fqXSJtr8h5KfXejE09bYD7ZJyVHNhMvgc4BMi20o='
WHERE
key_id = '49717ddda49a48851083a738f1b1a88a260d3755b6077f46867e7d72f137a573'
AND (
token = '892fqXSJtr8h5KfXejE09bYD7ZJyVHNhMvgc4BMi20o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)