UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgEei8QH2VnWC8K5ysshnJf/+w28/H9zV7JvMNGiUbI='
WHERE
key_id = 'e5da5382aef7f81bfd02dcd663b917460ba5a5b4fa49094792436fa33363843d'
AND (
token = 'XgEei8QH2VnWC8K5ysshnJf/+w28/H9zV7JvMNGiUbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)