UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8d7a5X7mhWexoA7g7/QqxNdinIIcfxpAVWG6HZ+/LT8='
WHERE
key_id = '959aa5416968af2c17fc2bfba306b83f1b191c123cf7167067b615ed7278a171'
AND (
token = '8d7a5X7mhWexoA7g7/QqxNdinIIcfxpAVWG6HZ+/LT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)