UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CfdIc8XSIez4b4h3ye42zh0OV+kjAokdPugkj3OLUWM='
WHERE
key_id = '2b8544d7505f106ce1b5768a53bf4f82c1cf9a21cb1284f9bd480b7a9a767cd2'
AND (
token = 'CfdIc8XSIez4b4h3ye42zh0OV+kjAokdPugkj3OLUWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)