UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPa4NmBUXPgCcT17epmu3u8/sOsMly3QLI1wzEB9vAU='
WHERE
key_id = '3ad565ea79950fe3519dba959b4569f77ca20ae0b561e212e1916e06fa356b4c'
AND (
token = 'KPa4NmBUXPgCcT17epmu3u8/sOsMly3QLI1wzEB9vAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)