UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zzR49MJO2N+usWtZZj2D+AwV4cVWCXJ+6bffY6l5mKw='
WHERE
key_id = 'dcf89025bc4903674676c90b18f39ed7492199ed733f7ec3887b1bd72bdfca3e'
AND (
token = 'zzR49MJO2N+usWtZZj2D+AwV4cVWCXJ+6bffY6l5mKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)