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