UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1u8WC2xBIqwZcCf/5UigwSVjgDxVFdLxcwppHFFrPRI='
WHERE
key_id = 'e949d15180eabed9b390fe9393f34273ac0bf8d25104b2089f826b255a9fefe5'
AND (
token = '1u8WC2xBIqwZcCf/5UigwSVjgDxVFdLxcwppHFFrPRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)