UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '028VuNwLjVTJzpM61IGH/slPAm4zxw31gxk3et9kTa0='
WHERE
key_id = '8920cfac4b30b2d2991778b61d4cde6757873faaf5c31a229989be5f31011d0a'
AND (
token = '028VuNwLjVTJzpM61IGH/slPAm4zxw31gxk3et9kTa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)