UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'os1+PPEya5R4x0IcgggFXZfvtjQ9b2XaKv4I8CM9F+k='
WHERE
key_id = 'fe0ee5d9503dc00b9e153d44719b66d13f8cc1cd41fbde7cd832d0f4f4e9f568'
AND (
token = 'os1+PPEya5R4x0IcgggFXZfvtjQ9b2XaKv4I8CM9F+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)