UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4BYHbIUp412yrZL17liHRdeNI0xIpRODjn38Gnr9IL4='
WHERE
key_id = '7425624e36c92b46cce8a5a08b28cdbf7a8d2e71e186337344b0a6e5d1527e05'
AND (
token = '4BYHbIUp412yrZL17liHRdeNI0xIpRODjn38Gnr9IL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)