UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3qCol5xFJ7QPx3IhQs0GFC1/px7KB+E+P3htsPZ13yc='
WHERE
key_id = 'b0c36b6305411ccd8bb82f7148885b07921418627d1b831c49a4c61a0155a0ab'
AND (
token = '3qCol5xFJ7QPx3IhQs0GFC1/px7KB+E+P3htsPZ13yc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)