UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yrNRSrhIGBElTY1JxqwxWcDY2OCo1Rl8luM/D8zXDbU='
WHERE
key_id = '10cfa547b2e0f60fcef2309524b3f7a9d4ba23cef5d03b164edf1304ff8866af'
AND (
token = 'yrNRSrhIGBElTY1JxqwxWcDY2OCo1Rl8luM/D8zXDbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)