UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7yMXFv++ZACJTqxIW9jLuKU/9aM94aKyzpBJ4j9tIVo='
WHERE
key_id = 'a1564761b605aaa613df3fabf94582e867409e8565bfffc37f3e39f4436f8d3b'
AND (
token = '7yMXFv++ZACJTqxIW9jLuKU/9aM94aKyzpBJ4j9tIVo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)