UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1pII8hUheN+Na5STS6O7FMWvmPBXJcVZ4dYeb73KG6U='
WHERE
key_id = 'ebb8b9c7c2ed9ce82e8bc25178056484951af3d13ce7a25bc919954c507b923e'
AND (
token = '1pII8hUheN+Na5STS6O7FMWvmPBXJcVZ4dYeb73KG6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)