UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JYvgABPvH/rBnwXWzpq9j8bPkVccCoPGHbp8ARsW9IY='
WHERE
key_id = '47030a20d87e14d297f17baf33e7359983c68badccc55c7adfd0f0df1a1517fa'
AND (
token = 'JYvgABPvH/rBnwXWzpq9j8bPkVccCoPGHbp8ARsW9IY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)